package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.CheckItem;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @author jshstart
 * @creat 2020-11-10 10:37
 */
public interface CheckItemMapper extends BaseMapper<CheckItem> {
    @Select("select tci.* from t_checkgroup_checkitem tgi\n" +
            "join t_check_item tci on tci.id=tgi.checkitem_id\n" +
            "where tgi.group_id=36")
    List<CheckItem> findAllItemByGroupId(Integer id);
//    @Update("update t_check_item set is_delete=#{is_delete} where id=#{id}")
//    int deleteById(CheckItem checkItem);
}
